Instructions for the wait & queues demo

StartDemo.cmd

Look at WaitStatsDemo1.sql
- problems with log

Look at WaitingTasks.sql
- look at latch stats
- look at waiting queries

- look at perfmon counters for Physical Disk C:, log growths

Stop the test

StartDemo2.cmd - bigger log, on SSD, larger batches
Look at WaitStatsDemo2.sql
- less log problems
- more data file problems

StartDemo3.cmd - adds in count queries
Look at WaitStatsDemo3.sql
- now seeing blocking too
